All Questions
47 questions
0votes
3answers
161views
Python API - store data in SQL AND NoSql
I am a student and am currently programming an API in Python. Among other things, it is possible to register, log in, create a user profile with data, etc. I would like to be able to store and ...
- 1
1vote
1answer
5kviews
SQL or NoSQL Database for a chat application?
currently I am working on a kind of "Chat" Application. The app consists of "threads". Each of this threads consist of "subthreads" in wich a user can send a message (...
- 65
1vote
1answer
465views
How to represent NoSQL entities
I've mainly studied SQL structures, and I know that the representation of the entities can look something like this: However, I'm building this app with MongoDB, so NoSQL DB. I'm aware that MongoDB ...
- 13
0votes
1answer
83views
Table design question - DynamoDB the right choice?
Our team has started to use AWS and one of our projects will require storing approval statuses of various recommendations in a table. There are various things that identify a single recommendation, ...
- 101
4votes
0answers
1kviews
Relational or non-relational database for storing and querying log data?
I'm planning to extend an application with logging of user events. (Client application via REST-API to Symfony). What is the preferred type of databases? Currently the log data is stored in a ...
1vote
3answers
3kviews
When would I pick NoSQL over SQL when dealing with partly schema-less data?
so, I'm currently developing a feature for a website of mine, which aims to gather a set of financial data from the user so the user can start and take care of a budget, as well as the website ...
- 389
-3votes
2answers
64views
Does it make sense for a large scale SaaS project to use a single all powerful SQL/RDBMS database?
Scalability seems to be a thing now. I was in a heated argument with one of my developer who insist on using MySQL for a data intensive application we are building. MySql is easy, fits the purpose and ...
- 121
-4votes
1answer
127views
Keeping JSON in database
I'm trying to create web app(flask or django-rest) that would scrape some data and save it to JSON so that it can be viewed in the frontend (VueJS). I'm wondering if it is better to save the scraped ...
- 161
-3votes
1answer
97views
Saving large files like Credit Reports in Data Store - SQL/NoSQL/ObjectStore
I am working on a project to save external credit bureau reports in database. These reports are typically big and could go from 0.5MB to 5.0 MB. Number of files will grow exponentially over the time ...
4votes
1answer
705views
What *really* is the difference between relational and non-relational data?
Here is where I am at right now: I know that relational data, like that found in relational databases like MySQL or Postgres, is relational because there are relations between the tables. That is the ...
1vote
0answers
62views
Partial database synchronisation across multiple databases
Currently we are looking for a solution to sync databases across multiple locations. We a location hierarchy such as Country -> State -> District -> Center. To increase speed and reliability of the ...
1vote
1answer
148views
Query by NoSQL keys versus SQL hash
I am trying to decide between a NoSQL (MongoDB) or a SQL (Oracle) database for my project. This database will be used to store output files from a set of parameters. I can model this as a MongoDB ...
0votes
2answers
606views
Most efficient way to get unique customer count
I'm working on a system that stores details of customer purchases for several stores. One statistic that they would like is to know how many unique customers they have had over a specified day range, ...
3votes
1answer
912views
How to think about queries in NoSQL
I'm writing a project for school - Tinder-like app. I thought of implementing database entirely in RDBMS (PostgreSQL). But now I think it's a good opportunity to get to know NoSQL systems a bit. I'm ...
- 141
0votes
2answers
595views
Migrating an Application from SQL to NoSQL [closed]
I am faced with taking a mvce's for SQL which happens to be the WideWorldImporters Database from Microsoft and migrating it to a NoSQL on mongodb. The system in question may use certain fractions of ...
